create table product(
   id char(36) ,
   pnum char(36) not null default '',
   name char(255) not null default '',
   type char(255),
   spec char(255),
   unit char(10),
   quality int default '0',
   remarks char(255),
   category char(50),
   baseprice double,
   singleprice double,
   bunchprice double,
   cxprice double,
   interprice double,
   specialprice double,
   producturl char(100),
   manufacturerid char(36),
   account_name char(150),
   weight int,
   imagepath char(100),
   imagename char(100),
   description char(255),
   isvalid tinyint(1),
   status tinyint(1),
   deleted tinyint(1),
   date_entered datetime,
   date_modified datetime,
   created_by char(36),
   primary key(id)
);
